- Notes 11/17
- A.1, A.2,and A.3 are completed
- next: working on pathway and graduation
- A.3 check for missing district-level data for students of color
- A.3 match district names in OSPI files and shape files
- Notes after 11/10 meeting
- In term of change, positive values indicate increase in SY2020-21 and negative values indicate decrease in SY2020-21 for all the plots in this file.
- Without specific demonstration, all differences are calculated between SY2018-19 (pre pandemic) and SY2020-21
A.1. Student Enrollment Both Count and change
Students of color or low income students are further disadvantaged during the pandemic in terms of enrollment. Particularly lower grade levels
A.1.1 Student Enrollment Count for Kindergarteners 6th and 9th Graders

A.1.2 Student Enrollment Percentagee for Kindergarteners 6th and 9th Graders
- percentage of student enrollment for sy2020-21
- percentage = student count of a student group in a certain month/student count of all students in the same month
- no results show minority groups have lower enroll percentage at per k level
- similar patterns for pre k, 6th, and 9th grade


A.1.3. Student Enrollment Change for Kindergarteners 6th and 9th Graders
Change from SY 2019-20 to SY 2020-21; NO SY 2018-29 ENROLL COUNTS DATA AT GRADE LEVEL;
- positive value means increase in SY 2020-21 from SY 2019-20




A.2. Student absence both count and change
Students of color or low income students are further disadvantaged during the pandemic in terms of abs. Particularly lower grade levels grade levels: Grade K, 3rd, 6th, 8th, 9th, 10th grade.
- measure: average absences per student
- for total absences
- higher grade levels have higher absences
- on average, for all the grade levels, minority groups have high absences
- top absences groups: American Indian/Alaskan Native, Native Hawaiian/Other Pacific Islander, Hispanic/Latino of any race(s)
- low-income group has higher absences than non-low income for all the grade levels
- for difference in absences between sy2018-19 and sy2020-21
- difference = absences in sy2018-19 (of particular student group in a certain month) - absences in sy2018-19 (of the same student group in that month)
- POSITIVE value means that absences in sy2020-21 is higher (an increase)
- for grade levels 6, 8, 9, and 10, absences in sy2020-21 is higher
- for kindergarten, absences decreased for group “all students” while increased for American Indian/Alaskan Native, Native Hawaiian/Other Pacific Islander, Hispanic/Latino of any race(s)
- for kindergarten, absences increased for low-income group while decreased for non-low income group
































A.3. Course Taking
A.3.1. Statewide breakdown by groups
- for Percentage of All Courses Taken Resulted in Non-Passing Grade
- state average decreased in sy2019-20 and increased in sy2020-21
- state ave in sy2021 is higher than state ave in sy2018-19 (before covid-19)
- the same groups have higher non-passing rate than state ave before and after covid-19
- in addition, gaps between those groups and the others increased from sy2018-19 to sy-2020-21



A.3.2.1 Geographical differences across districts in all non-passing grade from 2018-19 to 2020-21
students of color (excluding Asian)
For spatial plots: missing data (grey areas) results from
- missing and suppression at district level; e.g. Olympia School District
- some districts have data for only one of the SYs, then the changes are going to be NAs; e.g. Rainier Valley Leadership Academy; e.g. Everett School District
- some districts in the shape file do not appear in the ospi data (shows in “match district names with shape file” section), vice versa; e.g. Rainier Valley Leadership Academy
data for comparison among ethnicity groups was downloaded directly from OSPI website.
data for comparison between income groups was downloaded and scraped for each district and manually compiled
- Difference calculated by %nonpass (or %numerical failing) in SY2020-21 minus %nonpass (or %numerical failing) in SY 2018-19
- darker purple color indicates more increase in %nonpass (or %numerical failing) in SY2020-21
OGR data source with driver: ESRI Shapefile
Source: "/private/var/folders/49/491d763x2rld9t7457p70t1h0000gn/T/RtmpnqnTb3/53", layer: "53"
with 295 features
It has 18 fields


OGR data source with driver: ESRI Shapefile
Source: "/private/var/folders/49/491d763x2rld9t7457p70t1h0000gn/T/RtmpnqnTb3/53", layer: "53"
with 295 features
It has 18 fields


OGR data source with driver: ESRI Shapefile
Source: "/private/var/folders/49/491d763x2rld9t7457p70t1h0000gn/T/RtmpnqnTb3/53", layer: "53"
with 295 features
It has 18 fields


OGR data source with driver: ESRI Shapefile
Source: "/private/var/folders/49/491d763x2rld9t7457p70t1h0000gn/T/RtmpnqnTb3/53", layer: "53"
with 295 features
It has 18 fields


A.3.2.2 The gap in all non-passing in 2020-21 between students of color and white for each district
- Gap calculated by %nonpass among low-income minus %nonpass among non-low income in SY2020-21
- darker purple color indicates more nonpass/num failing grades among students of color
- darker purple color indicates more nonpass/num failing grades among low-income students
OGR data source with driver: ESRI Shapefile
Source: "/private/var/folders/49/491d763x2rld9t7457p70t1h0000gn/T/RtmpnqnTb3/53", layer: "53"
with 295 features
It has 18 fields

OGR data source with driver: ESRI Shapefile
Source: "/private/var/folders/49/491d763x2rld9t7457p70t1h0000gn/T/RtmpnqnTb3/53", layer: "53"
with 295 features
It has 18 fields



on track:
- 9th grade on track: did not get a grade of D or F. The % of students that received grades of A,B, C.
- Regular attendance, meaning that has more than 90% attendance during the year
- Dual credit (not prestigious): (AP/IB courses is more prestigious); therefore, less useful
- COVID-19 modified (beginning of the school year to march, 2019-20 school year). The “modified” may indicate that. then OSPI created a fall to march dataset for multiple years of data